
from sqlalchemy import *
from sqlalchemy import Column, ForeignKey
from sqlalchemy.orm import relation, backref
from sqlalchemy.types import Integer, Text

from suportepaispython.model import DeclarativeBase

class Pais(DeclarativeBase):
	__tablename__ = 'Pais'

	id=Column(Integer, primary_key=True)
									
	codigo = Column(Text,unique=True)
									    
	descricao = Column(Text)
									    
	codigoAuxiliar = Column(Text)
									    
	valor = Column(Text)
		

	unidadeFederativaCollection = relation("UnidadeFederativa",order_by="UnidadeFederativa.id",backref="Pais")


	def __init__(self, codigo, descricao, codigoAuxiliar, valor):
		self.codigo = codigo
		self.descricao = descricao
		self.codigoAuxiliar = codigoAuxiliar
		self.valor = valor
